Introduction

Now that you have the knowledge and skills to work with data warehouses, you can use these skills to design and implement a data warehouse for a company in the hands-on labs.

Scenario

You are a data engineer hired by a solid waste management company. The company collects and recycles solid waste across major cities in the country of Brazil. The company operates hundreds of trucks of different types to collect and transport solid waste. The company would like to create a data warehouse so that it can create reports like:

• Total waste collected per year per city

• Total waste collected per month per city

• Total waste collected per quarter per city

• Total waste collected per year per truck type

• Total waste collected per truck type per city

• Total waste collected per truck type per station per city